package com.itheima.mapper;

import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface MemberMapper {
    Member findByTelephone(@Param("telephone") String telephone);

    void add(Member member);

    Integer getMemberReport(@Param("dateBegin") String dateBegin, @Param("dateEnd") String dateEnd);

    Integer findTodayNewMember(@Param("today") String today);

    Integer findTotalMember();

    Integer findNewMemberAfterDate(@Param("date") String date);

    //查询男或女会员数量
    int findMemberGenderCount(int gender);

    //根据年龄范围查询会员数量
    int findCountByAgeScope(@Param("minAge") int minAge, @Param("maxAge") int maxAge);
}
